Previous Topic

Next Topic

Warehouses window

From Orders, select Manage inventory> Manage products, select a product from the list of Current Products, and click Warehouses

Delete button

Click to delete a product's warehouse. The following conditions exist for deleting a product's warehouse:

Product Code

(Display only) Displays the code of the product for which you are setting up warehouses and defining inventory parameters.

Warehouse

Enter a warehouse location for a product. Select the Find icon to look up a warehouse location; warehouse locations are defined on the Set up warehouses window (from Orders, select Set up warehouses).

Bin

(Optional) Use this field to define a specific bin where a product is stored in a warehouse.

Minimum Order Point

Enter a reorder point for a product's inventory. When a product's inventory at a warehouse drops to the reorder point, iMIS informs you that you need to reorder the product when you print the Product Reorder List report (from Orders, select Generate reports, select the Product report type, and select Product Reorder List). iMIS compares the products in inventory to the Minimum Order Point to determine if the product should print on the report.

Minimum Order Qty

Enter a minimum amount of a product to reorder for a warehouse. Often, the quantity entered depends on the order quantity required for receiving a vendor discount. When the inventory level drops below the Minimum Order Point, the suggested Minimum Order Qty prints on the Product Reorder List report (from Orders, select Generate reports, select the Product report type, and select Product Reorder List).

On Order

Enter the number of products currently on order for a warehouse.

The value entered in the On Order field is the value that displays in the On Order field on the Manage products window. If you store a single product's inventory in multiple warehouses, the On Order field on the Manage products window displays the combined total product quantity on order for all the warehouses.

iMIS automatically decreases the number of products entered in the On Order field on both the Inventory and Manage products windows when you post product receipts.

Expected Arrival

Enter the date a reordered product is expected to arrive at a warehouse.

Standard Cost

Enter the standard cost of a reordered product for a warehouse. You only need to enter a Standard Cost if you selected Standard Cost as the Valuation Method on the Inventory System Setup window (from Orders, select Set up module, and click Inventory).

Last Received

(Display only) Displays the last date a product receipt was posted to inventory for a warehouse. Only inventory receipts, and not inventory adjustments, update the Last Received field.

Income Account

Enter the income account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Inventory Account

Enter the inventory account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Cost of Goods Sold

Enter the cost of goods sold account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Adjustments Account

Enter the adjustment account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Quantities

On Hand - (Display only) Displays the total quantity of a product currently in inventory at a warehouse.

Reserved - (Display only) Displays the reserved quantity of a product (pre-invoiced products in open order status) in inventory at a warehouse. Reserved products include backorders.

Available - (Display only) Displays the quantity of a product currently available in inventory at a warehouse (On Hand products minus Reserved products).

Costs

Total - (Display only) Displays the total cost of a product in inventory at a warehouse. The total cost is a cumulative running balance of receipts minus the cost of goods sold and/or inventory adjustments.

Avg/Std - (Display only) Displays the average or standard cost of a product at a warehouse on a per unit basis, depending on the option selected to determine the cost of goods sold.

Last Cost - (Display only) Displays the last amount paid for a product in inventory at a warehouse. The cost is calculated on a per unit basis. Only inventory receipts, and not inventory adjustments, update the Last Cost field.

The value that displays in the Last Cost field is the value entered in the Unit Cost field on the Enter and edit receipts and adjustments window (from Orders, select Manage inventory> Enter and edit receipts and adjustments).

Warehouses

Displays all of the warehouses set up for a product. Each warehouse line item displays a warehouse's code and account information.

See Also

Defining Inventory Parameters for Multiple Warehouses

To define warehouse parameters

To edit warehouse parameters

To delete a product's warehouse


ASI logo 10.6 Production Release. Updated 2/24/2006 11:16:22 AM
Copyright © by Advanced Solutions International, Inc. All rights reserved.